{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Frais","Listes"],"not_rendered":{"images":2,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Frais","index":0,"n_rows":93,"n_cols":8,"rows_kept":93,"merged":[[0,0,0,7],[1,1,1,3],[1,4,1,7],[3,6,3,7],[4,5,5,7],[5,1,5,2],[36,1,36,4],[39,1,39,3],[40,1,40,3],[42,1,42,7],[43,0,43,7],[44,1,44,3],[44,4,44,7],[87,1,87,4],[92,1,92,7]]}
["\nNOTE DE FRAIS"]
[null,"Page 1",null,null,"2022-05-10"]
[]
[{"$nulls":6},"Total"]
[{"$nulls":5},{"$f":"totalpage1+totalpage2","v":{"v":0,"d":"0.00"}}]
[null,"Nom et Prénom"]
[]
[]
[null,"Date","Lieu","Motif","Détails","Coût","Km","Montant"]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais[[#This Row],[Motif]]=\"Frais de déplacement\",frais[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais[[#This Row],[Coût]], frais[[#This Row],[Km]])*cout_km, frais[[#This Row],[Coût]])","v":0}]
[]
[{"$nulls":4},"Total page 1",null,{"$f":"SUM(frais[Km])","v":0},{"$f":"SUM(frais[Montant])","v":0}]
[]
[null,"N° de compte pour versement:"]
[]
[]
[null,"Merci de joindre les justificatifs et d'envoyer ce document par email à finances@vbcfully.ch."]
["\nNOTE DE FRAIS"]
[null,"Page 2",null,null,{"$f":"E2","v":"2022-05-10"}]
[]
[null,"Date","Lieu","Motif","Détails","Coût","Km","Montant"]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[{"$nulls":6},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF(NOT(ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE))), VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],2,FALSE), \"<-km   \"),\"\")","v":""},{"$f":"IF(AND(frais5[[#This Row],[Motif]]=\"Frais de déplacement\",frais5[[#This Row],[Lieu]]<>\"\"), IF( ISNA(VLOOKUP(frais5[[#This Row],[Lieu]],tab_lieux[],1,FALSE)),frais5[[#This Row],[Coût]], frais5[[#This Row],[Km]])*cout_km, frais5[[#This Row],[Coût]])","v":0}]
[]
[{"$nulls":4},"Total page 2",null,{"$f":"SUM(frais5[Km])","v":0},{"$f":"SUM(frais5[Montant])","v":0}]
[{"$nulls":4},"Total page 1",null,{"$f":"SUM(frais[Km])","v":0},{"$f":"totalpage1","v":0}]
[{"$nulls":6},{"$f":"SUM(G89:G90)","v":0},{"$f":"SUM(H89:H90)","v":0}]
[]
[null,"Merci de joindre les justificatifs et d'envoyer ce document par email à finances@vbcfully.ch."]

{"sheet":"Listes","index":1,"n_rows":69,"n_cols":6,"rows_kept":69,"hidden":true}
["Raison",null,"Lieu","Distance",null,"Coût km"]
["Frais de bureau",null,"Anzère",86,null,0.4]
["Frais d'envoi",null,"Arbaz",70]
["Frais de déplacement",null,"Ardon",32]
["Frais d'essence pour le bus",null,"Ayent",72]
["Frais d'arbitres",null,"Baltschieder",140]
["Cours J&S",null,"Basse-Nendaz",52]
["Réunion, assemblée comité",null,"Bouveret",94]
["Autres",null,"Bramois",58]
[null,null,"Brig",158]
[null,null,"Chamoson",24]
[null,null,"Charrat",8]
[null,null,"Collombey",56]
[null,null,"Conthey",40]
[null,null,"Crans-Montana",100]
[null,null,"Erde",50]
[null,null,"Evionnaz",26]
[null,null,"Eyholz",144]
[null,null,"Fiesch",190]
[null,null,"Flanthey",84]
[null,null,"Fully",0]
[null,null,"Gampel-Steg",124]
[null,null,"Glis",158]
[null,null,"Granges",66]
[null,null,"Grimisuat",64]
[null,null,"Haute-Nendaz",66]
[null,null,"Lalden",144]
[null,null,"Le Châble",38]
[null,null,"Lens",82]
[null,null,"Les Marécottes",26]
[null,null,"Leuk",104]
[null,null,"Leukerbad",132]
[null,null,"Leytron",18]
[null,null,"Martigny",6]
[null,null,"Martigny-Combe",14]
[null,null,"Massongex",42]
[null,null,"Monthey",48]
[null,null,"Mörel",176]
[null,null,"Naters",160]
[null,null,"Niedergesteln",128]
[null,null,"Orsières",52]
[null,null,"Ovronnaz",40]
[null,null,"Pont-de-la-Morge",44]
[null,null,"Port-Valais",82]
[null,null,"Raron",130]
[null,null,"Reckingen",232]
[null,null,"Riddes",40]
[null,null,"Ried",164]
[null,null,"Saillon",8]
[null,null,"Saint-Gingolph",96]
[null,null,"Saint-Léonard",60]
[null,null,"Saint-Maurice",36]
[null,null,"Savièse",60]
[null,null,"Saxon",14]
[null,null,"Sierre",62]
[null,null,"Sion",50]
[null,null,"St. Niklaus",174]
[null,null,"Stalden",154]
[null,null,"Susten",100]
[null,null,"Termen",168]
[null,null,"Verbier",26]
[null,null,"Vercorin",108]
[null,null,"Vétroz",36]
[null,null,"Vex",68]
[null,null,"Veysonnaz",74]
[null,null,"Vionnaz",64]
[null,null,"Visp",140]
[null,null,"Vouvry",84]
[null,null,"Zermatt",210]